/**
 * Macro1 Macro
 * 宏由 17722 录制，时间: 2021/11/12
 */
function Macro1()
{	
	var index = 2;
	var sheet = Application.Worksheets.Item("Sheet1");
	
	var map = {};
	while (sheet.Range("A" + index).Value2) {
		map[sheet.Range("A" + index).Value2] = sheet.Range("B" + index).Value2;
		
		index++;
	}
	
	index = 2;
	while (sheet.Range("C" + index).Value2) {
		var keyArr = sheet.Range("C" + index).Value2.split('+');
		
		for (let j = 0;j < keyArr.length;j++) {
			let key = keyArr[j];
			if (sheet.Range("E" + index).Value2) {
				sheet.Range("E" + index).Value2 += '+' + map[key];
			} else {
				sheet.Range("E" + index).Value2 = map[key];
			}
		}
		index++;
	}
//	Application.Worksheets.Item("Sheet1").Range("E2").Value2 = Application.Worksheets.Item("Sheet1").Range("A1").Value2;
}

